QRZ! Ham Radio 9

home *** CD-ROM | disk | FTP | other *** search

/ QRZ! Ham Radio 9 / QRZ Ham Radio Callsign Database - Volume 9.iso / pc / files / misc / whamlog.txt < prev next >

Wrap

Text File | 1996-06-24 | 13.8 KB | 406 lines

WHAMLOG.DAT (c) 1995, Werner Funkenhauser The information provided in WHAMLOG.DAT is edited from the FCC's file AMDATA.DAT.GZ. That file is publicly available from the FCC's server at FTP.FCC.GOV. WHAMLOG.DAT attempts to reduce this massive data into a form easily useable by Mediumwave DXers. The data contained in WHAMLOG.DAT is simple ASCII format and can be easily manipulated in a wordprocessor. Use 12-15 cpi as the font size, to produce neat output, one record per line when printing. Users have imported the file into spreadsheets and into database programs also. Even simple DOS commands such as FIND and TYPE may be used to filter some of the information into secondary files. For example, the DOS command, FIND " BR. " < WHAMLOG.DAT > BRAZIL.DAT, will output all Brazilian records into the file BRAZIL.DAT. WHAMLOG.DAT is made available free of charge and periodic update will be made available, also free of charge. Although free, if you decide to use it, please e-mail me and indicate your full name in your message. That way I have an idea of who is using the file. I am currently working on a couple of executable files that permit convenient searching and printing of this data. These will be available as shareware at a nominal cost in the near future. Letting me know you have a copy of WHAMLOG.DAT will permit me to notify you of their availability. Enjoy! ----------------------------------------------------------------- Please send e-mail advising me that you have a copy of WHAMLOG.DAT. Please don't distribute in modified form. =====>Thanks!<====== Werner Funkenhauser 28 Avenue Road Cambridge, Ontario Canada N1R 1B7 Internet: werner.funkenhauser@odxabbs.tor250.org werner.funkenhauser@canrem.com funkenhauser@frontier.canrem.com FIDO Shortwave Echo: Werner Funkenhauser RECORD FORMAT OF WHAMLOG: ========================= 10 20 30 40 50 60 70 *----*---|---*-----|---------|*--*---*-|----*-*--|*-*------|---------|---*---- 0530 CFHS FORT FRANCES ON CA. 000050 U ND1 U N48 36 35 W093 24 00 861203 0530 CIAO BRAMPTON ON CA. 000250 N DAD U N43 35 20 W079 52 54 910214 0530 CIAO BRAMPTON ON CA. 001000 D DAD U N43 35 20 W079 52 54 910214 1610 CFOS COLLINGWOOD ON CA. 001000 N ND1 U N44 28 45 W080 10 48 950419 1060 S LAURENT 1 FG. 001000 D ND2 U N05 30 15 W054 01 44 930409 1060 S LAURENT 1 FG. 001000 N ND2 U N05 30 15 W054 01 44 930409 1070 CAYENNE 1 FG. 020000 D ND2 U N04 53 40 W052 19 53 930409 1070 CAYENNE 1 FG. 020000 N ND2 U N04 53 40 W052 19 53 930409 *----*---|---*-----|---------|*--*---*-|----*-*--|*-*------|---------|---*---- ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ A B C D E F G H I J K --------10--------20--------30--------40--------50--------60--------70-------- NOTES ===== ================================================================== These notes are edited from the FCC Dictionary File (AMDICTIO.TXT) that accompanies the full FCC database AMDATA.DAT.GZ. Items marked with an asterisk pertain to the abbreviated version of WHAMSHRT.DAT. =================================================================== A) Frequency * 1 The AM frequency, ranging from 540 through 1700. If the frequency is below 1000, a leading zero is included. In Region 2, the frequencies are in 10 kHz increments. In Regions 1 and 3, the frequencies are in 9 kHz increments. B) Call Sign * 6 The Call Sign of the station or application. For applications and construction permits which do not have Call Signs a value of "NEW" is used. C) City * 14 The city in which the station is licensed or proposed. D) State * 31 The state or province in which the station is licensed or proposed. The possible codes depend on the country. Here are the possibilities: For the United States (country is "US"), we have the following abbreviations for the states, etc.: AK Alaska. AL Alabama. AR Arkansas. AS American Samoa. AZ Arizona. CA California. CO Colorado. CT Connecticut. DC The District of Columbia DE Delaware. FL Florida. FM the Federated States of Micronesia, which is a part of the Caroline Islands. GA Georgia. GU Guam. HI Hawaii. IA Iowa. ID Idaho. IL Illinois. IN Indiana. KS Kansas. KY Kentucky. LA Louisiana. MA Massachusetts. MD Maryland. ME Maine. MH the Republic of the Marshall Islands. MI Michigan. MN Minnesota. MO Missouri. MP the Northern Marianas. MS Mississippi. MT Montana. NC North Carolina. ND North Dakota. NE Nebraska. NH New Hampshire. NJ New Jersey. NM New Mexico. NV Nevada. NY New York. OH Ohio. OK Oklahoma. OR Oregon. PA Pennsylvania. PR Puerto Rico. PW the Republic of Palou, which is part of the Caroline Islands. RI Rhode Island. SC South Carolina. SD South Dakota. TN Tennessee. TX Texas. UT Utah. VA Virginia. VI the U.S. Virgin Islands (not the British Virgin Islands). VT Vermont. WA the state of Washington (not Washington, DC). WI Wisconsin. WV West Virginia. WY Wyoming. For Canada (country is "CA"), we have the following abbreviations for the Canadian provinces: AB Alberta. BC British Columbia MB Manitoba NB New Brunswick NF Newfoundland NS Nova Scotia NT Northwest Territories ON Ontario PE Prince Edward Island QU Quebec SA Saskatchewan YU Yukon For Mexico (country is "MX"), we have the following abbreviations for the Mexican states: AG Aguascalientes BN Baja California North BS Baja California South CH Chihuahua CI Coahuila CL Colima CM Campeche CS Chiapas DF Federal District DU Durango GR Guerrero GT Guanajuato HG Hidalgo JA Jalisco MC Michoacan ML Morelos MX Mexico NA Nayarit NL Nuevo Leon OA Oazaca PU Puebla QE Queretaro QR Quintana Roo SI Sinaloa SL San Luis Potosi SO Sonora TA Tamaulipas TB Tabasco TL Tlaxcala VC Vera Cruz YC Yucatan ZA Zacatecas E) Country * 34 A two-character field indicating which country the station is located in. Following is a list of 2-character country abbreviations that are used. These correspond to those used in Federal Information Processing Standards (FIPS) Publication 10-3, February 9, 1984. However, the following list is an abbreviated version of FIPS Pub 10-3, covering only the abbreviations which we use. (NOTE: a period has been added to this field by the author, in order that the DOS FIND filter may be used to extract countries (CAnada and not CAlifornia --- Werner Funkenhauser 08/15/1995). AC Antigua and Barbuda AR Argentina AV Anguilla BB Barbados BD Bermuda BF The Bahamas BH Belize BL Boliva BR Brazil CA Canada CI Chile CJ Cayman Islands CO Colombia CS Costa Rica CU Cuba DO Dominica DR Dominican Republic EC Ecuador ES El Salvador FA Falkland Islands (Islas Malvinas) FG French Guiana GJ Grenada GL Greenland GP Guadeloupe GT Guatemala GY Guyana HA Haiti HO Honduras JM Jamaica MB Martinique MH Montserrat MX Mexico NA Netherlands Antilles NS Suriname NU Nicaragua PA Paraguay PE Peru PM Panama SB St. Pierre and Miquelon SC St. Christopher and Nevis ST St. Lucia TD Trinidad and Tobago TK Turks and Caicos Islands US United States UY Uruguay VC St. Vincent and the Grenadines VE Venezuela VI British Virgin Islands F) Power * 38 The nominal power of the station, as defined in Section 73.14, in kilowatts. This is not necessarily the effective effective radiated power, the transmitter power, the antenna input power, etc. There is an implied decimal point between characters 4 and 5. Read it in FORTRAN with an F9.5 format. [Note a leading zero has been stripped off and the implied decimal point is now between characters 3 and 4. Read the examples as 50 watts (.050 Kilowatts) and 20000 watts (20 Kilowatts) - Werner Funkenhauser, Aug 17, 1995] G) Hours of Oper. * 45 The operating hours during which the parameters in this record are used. Since the data base is an engineering data base, the hours of operation are used to tell which records are used in which studies. Thus, for example, a DA1 limited time station will have hours of operation of "U" because it is used in both daytime and nighttime studies; it does not mean that the station operates unlimited time. Distinguish this from the complete schedule. Possible values are: U Unlimited. I.e., both day and night, or portions thereof. N Nighttime. D Daytime. C Critical Hours. R Canadian Restricted. P Pre-sunrise. Critical Hours is that time from Sunrise to two hours after Sunrise, and from two hours before Sunset until Sunset, local time. During that time, certain stations may be operating with reduced facilities as a result of Section 73.187 of the commission's Rules. Canadian Restricted hours are similar to Critical Hours, except that the restriction results from the January 17, 1984, U.S.-Canadian AM Agreement. See Appendix 8 to Annex 2. Canadian Restricted Hours are called "Critical Hours" in the U.S.-Canadian Agreement, but in the data base, we call them "Canadian Restricted Hours" to distinguish them from the domestically defined critical hours in Section 73.187. Canadian Restricted Hours is that from Sunrise to one and one-half hours after Sunrise, and from one and one-half hours before Sunset until Sunset, local time. U.S. stations operate with restricted hours because of Canadian stations, and vice-versa. H) Antenna Mode * 47 The mode of the complete antenna system. It indicates whether directional or non-directional, number of patterns, etc. For example: DA1, DA2, DAN, ND1, ND2. I) Complete Schedule 51 The Complete Schedule for this station. Distinguish this from Hours of Operation. Possible values are: D Daytime only. N Nighttime only. U Unlimited time. L Limited time. H Specified Hours. For example, a DA2 station has different patterns for daytime and nighttime. Thus, there would be a daytime logical record and a nighttime logical record. The hours of operation would be "D" in the daytime record, and "N" in the nighttime record, but the complete schedule would be "U" in both records. J) Latitude Dir * 53 The direction for the latitude. It is "N" for North Latitude, and "S" for South Latitude. Latitude Degrees * The degrees portion of the latitude. Latitude Minutes * The minutes portion of the latitude. Latitude Seconds * The seconds portion of the latitude. Longitude Dir * The direction for the longitude. It is "W" for West Longitude, and "E" for East Longitude. Longitude Degrees * The degrees portion of the longitude. Longitude Minutes * The minutes portion of the longitude. Longitude Seconds * The seconds portion of the longitude. K) Change List Date * 74 The date of the change list in YYMMDD format.